1. CREATE DATABASE: CREATE DATABASE MyDatabase;2. CREATE TABLE: CREATE TABLE Employees ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), DepartmentID INT );3. ALTER TABLE: ALTER TABLE Employees ADD Salary DECIMAL(10, 2);4. DROP TABLE: DROP TABLE Employees;5. INSERT INTO: INSERT INTO Employees (EmployeeID, FirstName, LastName, DepartmentID) VALUES (1, 'John', 'Doe', 101);6. UPDATE: UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 1;7. DELETE FROM: DELETE FROM Employees WHERE EmployeeID = 1;8. SELECT: SELECT * FROM Employees;9. DISTINCT: SELECT DISTINCT DepartmentID FROM Employees;10. WHERE: SELECT * FROM Employees WHERE DepartmentID = 101;11. ORDER BY: SELECT * FROM Employees ORDER BY LastName;12. GROUP BY: SELECT DepartmentID, COUNT(*) FROM Employees GROUP BY DepartmentID;13. HAVING: SELECT DepartmentID, COUNT(*) FROM Employees GROUP BY DepartmentID HAVIN سارتر چه بر سر جایزۀ نوبل آورد...
ما را در سایت سارتر چه بر سر جایزۀ نوبل آورد دنبال می کنید
برچسب : نویسنده : شهریاری web2web بازدید : 55 تاريخ : سه شنبه 30 آبان 1402 ساعت: 15:48